package com.baseframe.file.mapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baseframe.file.entity.BaseFile;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baseframe.file.entity.vo.BaseFileVO;
import com.baseframe.mybatis.utils.PageInfo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**

* @description 针对表【base_file】的数据库操作Mapper
* @createDate 2023-06-28 06:42:04
* @Entity com.baseframe.file.entity.BaseFile
*/
public interface BaseFileMapper extends BaseMapper<BaseFile> {

    @Select("select id, original_filename, filename, file_key, link, label, user_id from base_file where is_deleted = 0 and user_id = #{userId} order by create_time desc")
    Page<BaseFileVO> getFilePageList(Page<BaseFileVO> page,@Param("userId") Long userId);
}




